package pers.hxy.lookweather.db;

public class ChinaCityConfig {
    public static final String CHINA_CITY_LIST_CSV_FILE = "LocationList/China-City-List-latest.csv";
    public static final String CHINA_CITY_LIST_SQL_FILE = "sql/china_city_list.sql";
    public static final String CHINA_CITY_LIST_TABLE_NAME = "china_city_list";

//    public static final int INDEX_Location_ID = 0;
//    public static final int INDEX_Location_Name_EN = 1;
//    public static final int INDEX_Location_Name_ZH = 2;
//    public static final int INDEX_ISO_3166_1 = 3;
//    public static final int INDEX_Country_Region_EN = 4;
//    public static final int INDEX_Country_Region_ZH = 5;
//    public static final int INDEX_Adm1_Name_EN = 6;
//    public static final int INDEX_Adm1_Name_ZH = 7;
//    public static final int INDEX_Adm2_Name_EN = 8;
//    public static final int INDEX_Adm2_Name_ZH = 9;
//    public static final int INDEX_Timezone = 10;
//    public static final int INDEX_Latitude = 11;
//    public static final int INDEX_Longitude = 12;
//    public static final int INDEX_AD_code = 13;
//    public static final String[] CHINA_CITY_LIST_TABLE_COLUMN_NAMES = new String[] {
//            "Location_ID",
//            "Location_Name_EN",
//            "Location_Name_ZH",
//            "ISO_3166_1",
//            "Country_Region_EN",
//            "Country_Region_ZH",
//            "Adm1_Name_EN",
//            "Adm1_Name_ZH",
//            "Adm2_Name_EN",
//            "Adm2_Name_ZH",
//            "Timezone",
//            "Latitude",
//            "Longitude",
//            "AD_code",
//    };

    public enum CHINA_CITY_LIST_INDEX {
        Location_ID,
        Location_Name_EN,
        Location_Name_ZH,
        ISO_3166_1,
        Country_Region_EN,
        Country_Region_ZH,
        Adm1_Name_EN,
        Adm1_Name_ZH,
        Adm2_Name_EN,
        Adm2_Name_ZH,
        Timezone,
        Latitude,
        Longitude,
        AD_code;
    };

    public static final int CHINA_CITY_LIST_COLUMN_COUNT = CHINA_CITY_LIST_INDEX.values().length;

    public static final String[] CHINA_CITY_LIST_COLUMN_NAMES = new String[CHINA_CITY_LIST_COLUMN_COUNT];
    static {
        for (CHINA_CITY_LIST_INDEX index : CHINA_CITY_LIST_INDEX.values()) {
            CHINA_CITY_LIST_COLUMN_NAMES[index.ordinal()] = index.name();
        }
    }

    public static final String SP_CHINA_CITY_LIST_VERSION_INFO = "China-City-List-Version";
}
